# MySQL obNAbv&XgAK

## Om
#### MySQL̐ݒt@C
C\ProgramData\MySQL\MySQL Server 8.0\my.ini
oCiO̖OĂꏊ́ulog-binvŌƕ\B

#### /obNAbvꂽt@C(oCiO)̏ꏊ
C\ProgramData\MySQL\MySQL Server 8.0\Data

#### ݂̍/obNAbvɎgĂt@CmF
  irootŁjSHOW MASTER STATUS;

## K1 tobNAbv
- WindowsϐpathύX
- Rg[plVXeƃZLeBVXeVXȅڍאݒ聨ϐ
- VXeϐ́uPathvNbNAuҏWvuVKv
- uC:\Program Files\MySQL\MySQL Server 8.0\bin\vƓ͂AuOKv
LɂR}hvvgŁumysqlvR}hsł悤ɂȂ

- ȉ̃R}hR}hvvgŎs
mysqldump --lock-all-tables -A -uroot -p<root[ŨpX[h> > C:\backup_test.sql
ChCuɃobNAbvt@C

## K1
ȉ̗vɏ]Af[^x[XobNAbvĂB
#### v
	- ۑꏊ
		- ChCu
	- ۑΏ
		- rezodb
	- obNAbvt@C
		- backup_<t>_<O[}1>-<[}>.sqliFbackup_20200414_m-yoshida.sqlj
	- mysqldump̃IvV
		- --flush-logs
		- --lock-all-tables
		- -u
		- -p
#### qg
	- mysqldumṕu-Av́uׂẴf[^x[XvƂӖB
	- mysqlR}hŁArezodbɃANZXƂɂǂɁurezodbvƓ͂H
	- IvV̈Ӗcu--flush-logsv=oCiO[e[giȍ~̑͐VoCiOɕۑj
	                    u--lock-all-tablesv=̓삪sĂŒ́AׂẴe[ubN

## K2 obNAbv
1. ǂ̃[Ułǂ̂rezodbɃANZXAuser_tableɈȉ̃f[^ǉĂB
INSERT INTO employee VALUES (20000, '<̃tl[>', '<̃tl[Ji>','my@hoge.jp','xxx','10');

2. ȉ̃R}hR}hvvgŎs܂B
   mysqlbinlog "C:\ProgramData\MySQL\MySQL Server 8.0\Data\<oCiOt@C>" > C:\backup_test2.sql

## K2
ȉ̗vɏ]Af[^x[XobNAbvĂB
### vF
	- ۑꏊ
		- ChCu
	- ۑΏ
		- ݂̍obNAbv
	- obNAbvt@C
		- backup2_<t>_<O[}1>-<[}>.sql

## K3 XgA

ӁI@OɁALtH_ɕۑobNAbv݂邱ƁAeςɂȂĂȂi2̃obNAbvt@CTCYɂȂĂȂjmFĂB

1. rootrezodbɃOCAȉ̃R}hsĂB
   SHOW TABLES FROM rezodb;

2. ׂẴe[u폜܂Bȉ̃R}hAe[usĂB
   DROP TABLES <e[u>;

3. f[^x[XXgA܂B
   \qmysql甲oAȉ̃R}hs܂B
   mysql -uroot -p<rootpX[h> rezodb < <LtH_ɕۑtobNAbṽtpX>

4. XgAf[^x[XtobNAbv̂̂ɂȂĂ邩mF܂B
   user_table̓emFĂB

5. obNAbv̓eXgA܂B
   \qmysql甲oAȉ̃R}hs܂B
   mysql -uroot -p<rootpX[h> rezodb < <LtH_ɕۑobNAbṽtpX>

6. XgAf[^x[XobNAbv̂̂ɂȂĂ邩mF܂B
   user_table̓emFĂB

7. {̑SobNAbv쐬ĂB
- v
	- ۑꏊ
		- ChCu̒
	- ۑΏ
		- rezodbû݁v
	- obNAbvt@C
		backup3_<t>_<O[}1>-<[}>.sql
	- mysqldump̃IvV
		- --flush-logs
		- --lock-all-tables
		- -u
		- -p

